﻿create PROCEDURE [dbo].[proc_MarketProjectItem_SaveSumSpendingTotals]
(
	@mid INT
)

AS
BEGIN

SELECT SUM(SpendingTotals) FROM MarketProjectItem mpi JOIN ProT_ClassT3 pct3 ON mpi.T3=pct3.id
WHERE MID=@mid

	SET NOCOUNT ON;


END
